-- =============================================    



-- Author:  <Author,,Name>    



-- Create date: <Create Date,,>    



-- Description: <Description,,>    



-- =============================================    



ALTER PROCEDURE [dbo].[GetTodayMatcheForClient]    

 -- Add the parameters for the stored procedure here    

AS    
BEGIN    
 -- SET NOCOUNT ON added to prevent extra result sets from    
 -- interfering with SELECT statements.    
 SET NOCOUNT ON;    
    -- Insert statements for procedure here    
	SELECT ms.Id as Id, t.TeamName as Team1 ,t1.TeamName as Team2, (t.TeamName + ' VS ' + t1.TeamName) as Teams,Date, Time,  
    t.Id as TeamAId, t1.Id as TeamBId   
    from MatchSchedule ms    
    INNER JOIN Team t on ms.Team1 = t.Id    
	INNER JOIN Team t1 on ms.Team2 = t1.Id    
	WHERE CAST(ms.Date as DATE) <= CAST(GETUTCDATE() as DATE) and ms.IsActive = 1 and ms.IsDeleted = 0   
	AND ms.Id NOT IN (Select MatchScheduleId from MatchResults)
END
